package com.wltjack.springboot.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.wltjack.springboot.vo.OrganizationVO;

@Mapper // @Mapper是mybatis框架用于声明Mapper接口的注解
public interface OrganizationMapper {
	
	@Select("SELECT ID as id,`NAME` as name,TYPE as type,CONTACTS_NAME as contactsName,PHONE_NUM as phoneNum,ADDRESS as address FROM crm.organization")
	List<OrganizationVO> getAllOrganizations();
	

}
